import openpyxl

workbook = openpyxl.load_workbook('约人.xlsx')

worksheet = workbook.worksheets[0]
print(worksheet)

li = []
def get_rows():
    print('*'*20,'所有数据','*'*20)
    for row in worksheet.rows:
        for cell in row:
            if cell.value != None:
                print(cell.value,end=' ')
        print()
